主页 > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

AnswerBea (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

您必须登录，才能发布信息讨论。

类似词条

Dragon Dictation
软件; 手机软件

A speech recognition App developed by Nuance Communications ...

Safari
软件; Web 浏览器

Apple's proprietary web browser which is both available ...

Evernote
软件; 生产力软件

Evernote is a simple glassware that makes taking notes easy ...

Cyanogen
软件; 操作系统

Cyanogen is a US-based mobile software company that ...

resample
软件; 图形设计软件

To change the resolution and dimensions of a bitmap. ...

LivingSocial
软件; 手机软件

Similar to Groupon, you can use this app to gain hand-held ...

创建者

精选词汇表

The Best Set-Top Box You Can Buy

类别： 技术   1 5 词条

Basketball Fouls

类别： 体育   1 10 词条

Greek Landscape: The Sights

类别： 历史   2 20 词条

The 12 Best Luxury Hotels in Jakarta

类别： 旅游   1 12 词条

Most Brutal Torture Technique

类别： 历史   1 7 词条

Catholic Rites and Rituals

类别： 宗教   1 20 词条

TermWiki is ranked top innovative application by IDC.

© 2024 CSOFT International, Ltd.       京ICP备12032581号-1

关注我们：